2014-09-04 - 10735 - Rel Notes - New Era Japan IT Deployment - Contract Creation from Order Sheet #SAPReleases2014

Release Notes - Draft


10735 - Rel Notes - New Era Japan IT Deployment - Contract Creation from Order Sheet


Admin Info


Purpose
 Contract Creation from Order Sheet
Release No
 001
Submitted on
 09/04/2014
Submitted by
 Surya Basa
Environment
 NECNED to NECNEQ
Sent To
 Daniel Brennan
Object(s) created by
 Venkat Kondapally
Object(s) tested by
 Surya Basa / Deepak Yasam / Siba Mohapatra
Transport Status
 Created in NECNED100

Transport and Technical Objects

Sl.
 Transport ID
 Description
 Object Name
1
 NEDK926949
 SD:10735:Japan Order Sheet Contract Creation
 ZSD_JPN_ORD_SHT_CONTRACT

Release Notes

For Infrastructure

NA

For Requestor

NA


Test Notes

System : NECNED300

Test ID
 Test Scenarios
 Expected Results
 Actual Results
 P/F
 Load Sheet and Contract #
 Notes
 Tested By
 QA By
01.
 Fill the order sheet with 3 materials .For item 3 the quantities are not given for the corresponding size and upload into the sell sheet program and execute it.
 Contract should not be created as there are no quantities for the size of item 3.
 Contract is created with 2 materials.

Exception Reason:
The program will check both the quantities & material and as there is no quantity for item 3, the contract is created with 1, 2 materials.
 P
 SD0821-01


Contract # 40001796
 N/A
 Surya/Siba
 Surya/Deepak
02.
 Fill the order sheet with 3 materials with two valid (item 1, 2) and one invalid material with quantities (item 3).Upload into the sell sheet program and execute it.
 Contract should be not be created.
 Contract is not created.
 P
 SD0821-02

Contract # NA
 N/A
 Surya/Siba
 Surya/Deepak
03.
 Upload the order sheet without Ship-to value, into the sell sheet program and execute it.
 Contract should not be created.
 Contract is created with same SP partner as SH.

Exception Reason:
The program considers SP partner and applies to SH partner in the contract.
 P
 SD0821-03

Contract # 40001797
 N/A
 Surya/Siba
 Surya/Deepak
04.
 Upload the order sheet without Requested delivery date into the sell sheet program and execute it.
 Contract should not be created.
 Contract is created with requested delivery date.

Exception Reason: The program considering document creation date as requested delivery date in the contract.
 P
 SD0821-04

Contract # 40001798
 N/A
 Surya/Siba
 Surya/Deepak
05.
 Upload the order sheet with invalid month/date into the sell sheet program and execute it.
 Contract should not create and message: ‘Invalid Date, Enter Date in Correct Format’ should come.
 Contract is not created.
 P
 SD0821-05

Contract # NA
 N/A
 Surya/Siba
 Surya/Deepak
06.
 Upload a protected order sheet, filled with the required data into the sell sheet program then execute it.
 Contract should create accordingly with the data filled in excel file.
 Contract is created.
 P
 SD0821-06

Contract # 40001801
 N/A
 Surya/Siba
 Surya/Deepak
07.
 Upload an unprotected order sheet, filled with the required data into the sell sheet program then execute it.
 Contract should create accordingly with the data filled in excel file.
 Contract is created.
 P
 SD0821-07

Contract # 40001802
 N/A
 Surya/Siba
 Surya/Deepak
08.
 Upload an order sheet with .xls format filled with the required data into the sell sheet program and execute it.
 Contract should create accordingly with the data filled in excel file.
 Contract is created.
 P
 SD0821-08

Contract # 40001803
 N/A
 Surya/Siba
 Surya/Deepak
09.
 Upload an order sheet with .xlsx format filled with the required data into the sell sheet program then execute it.
 Contract should create accordingly with the data filled in excel file.
 Contract is created.
 P
 SD0821-09

Contract # 40001804
 N/A
 Surya/Siba
 Surya/Deepak
10.
 Upload an order sheet, filled with future requested delivery date into the sell sheet program then execute it.
 Contract should create with the requested delivery date mentioned in excel file and it should applicable on all the line items.
 Contract is created with the future requested delivery date mentioned in excel file and it applied on all the line items in the contract.
 P
 SD0821-10

Contract # 40001805
 N/A
 Surya/Siba
 Surya/Deepak
11.
 Upload an order sheet with same sold-to and ship-to partner into the sell sheet program and execute it.
 Contract should create with same partner number as sold-to and ship-to.
 Contract created with same partner for both sold-to and ship-to.
 P
 SD0821-11

Contract # 40001806
 N/A
 Surya/Siba
 Surya/Deepak
12.
 Upload an order sheet with different sold-to and ship-to partner into the sell sheet program and execute it.
 Contract should create with different sold-to and ship-to partner number.
 Contract created with different partners for sold-to and ship-to.
 P
 SD0821-12

Contract # 40001823
 N/A
 Surya/Siba
 Surya/Deepak
13.
 Upload an order sheet with requested delivery date format (MM/DD/YYYY) into the sell sheet program and execute it.
 Contract should create with requested delivery date format MM/DD/YYYY at header and it should applicable to all the line items and schedule line level.
 Contract created with the date format MM/DD/YYYY.
 P
 SD0821-13

Contract # 40001824
 N/A
 Surya/Siba
 Surya/Deepak
14.
 Upload an order sheet without Cancel date into the sell sheet program and execute it.
 Contract should not be created without cancel date.
 Contract is created with calculated cancel date.

Exception Reason: As per the custom sell sheet program, if no cancel date is given in the sheet then the program calculates 365 days from the requested delivery date and make the date as cancel date.
SD0821-14

Contract # 40001822
 N/A
 Surya/Siba
 Surya/Deepak
15.
 Upload an order sheet with invalid grid sizes for the material into the sell sheet program and execute it.
 Contract should be created with rejection reason J2 for the invalid sizes.
 Contract is created with rejection reason J2 for the invalid sizes.
 P
 SD0821-15

Contract # 40001825
 N/A
 Surya/Siba
 Surya/Deepak
16.
 Upload an order sheet with materials of different master grids in the sell sheet program and execute it.
 Contract should create with materials of different master grids.
 Contract created with materials of different master grids.
 P
 SD0821-16

Contract # 40001808
 N/A
 Surya/Siba
 Surya/Deepak
17.
 Upload an order sheet as below into the sell sheet program and execute it.

Item-1 with Material number, size, and quantity.

item-2 with only size and quantity.
 Contract should be created with item-1(material number, size and quantity).
 Contract is created with only item 1.

Exception Reason: The program will check both the quantities & material and as there is no material number for item 2, the contract is created with item 1.
 P
 SD0821-19
Contract # NA
 N/A
 Surya/Siba
 Surya/Deepak
18.
 Upload an order sheet with 50 items and sizes, to check with many materials.
 Contract should create successfully.
 Contract is created successfully without any error log.
 P
 SD0821-21

Contract # 40001829
 N/A
 Surya/Siba
 Surya/Deepak
19.
 Upload an order sheet with customer marked for deletion indicator, in the sell sheet program and execute it.
 Contract should create and system should prompt message regarding customer marked for deletion, once user display the contract.
 Contract created with the customer having deletion indicator enabled.
 P
 SD0821-22

Contract # 40001811
 N/A
 Surya/Siba
 Surya/Deepak
20.
 Upload an order sheet with invalid customer into the sell sheet program and execute it.
 Contract should not be created.
 Contract is not created.
 P
 SD0821-23

Contract # NA
 N/A
 Surya/Siba
 Surya/Deepak
21.
 Fill the order sheet with Materials with enough stock and availability check as Z2 in the MM .Upload into the sell sheet program and execute it.
 Contract should be created and quantities should be confirmed on the requested delivery date.
 Contract is created and quantities should be confirmed on the requested delivery date.
 P
 SD0821-24

Contract # 40001826
 N/A
 Surya/Siba
 Surya/Deepak
22.
 Fill the order sheet with Materials with no stock and availability check as Z2 in MM. Upload into the sell sheet program and execute it.
 Contract should be created by confirming the delivery date as there is no enough stock on the requested delivery date.
 Contract is created and system proposed next possible delivery date.
 P
 SD0821-25

Contract # 40001813
 N/A
 Surya/Siba
 Surya/Deepak
23.
 Fill the order sheet with Materials with enough stock and availability check as Z3. Upload into the sell sheet program and execute it.
 Contract should be created and quantities should be confirmed on the requested delivery date.
 Contract is created and quantities should be confirmed on the requested delivery date.
 P
 SD0821-26

Contract # 40001815
 N/A
 Surya/Siba
 Surya/Deepak
24.
 Fill the order sheet with Materials with no stock and availability check is Z3. Upload into the sell sheet program and execute it.
 Contract should be created and material/sizes are rejected with J0 as there is no stock.
 Contract is created and material/sizes are rejected with J0 as there is no stock.
 P
 SD0821-27

Contract # 40001816
 N/A
 Surya/Siba
 Surya/Deepak
25.
 Fill the order sheet with items as below with stock available on requested delivery date and upload into the sell sheet program and execute it.

Item-1 - with availability check is Z2

Item-2 - with availability check is Z3
 Contract should be created and quantities should be confirmed on the requested delivery date.
 Contract is created and quantities are confirmed on the requested delivery date.
 P
 SD0821-28

Contract # 40001818
 N/A
 Surya/Siba
 Surya/Deepak
26.
 Fill the order sheet with 2 items as below with no stock available on requested delivery date. Upload into the sell sheet program and execute it.

Item-1 - with availability check is Z3 and

Item-2 with availability check is Z2
 Contract should be created and program should propose next possible delivery date for item-2 (Availability check is Z2) and

For item-1 (Availability check is Z3) system should propose rejection reason J0.
 Contract created and system proposed next possible delivery date for item-2 (Availability check is Z2) and

for item-1 (Availability check is Z3) rejection reason J0.
 P
 SD0821-29

Contract # 40001819
 N/A
 Surya/Siba
 Surya/Deepak

SD0821-01.xlsSD0821-04.xlsSD0821-07.xlsSD0821-10.xls

SD0821-02.xlsSD0821-05.xlsSD0821-08.xlsSD0821-11.xls

SD0821-03.xlsSD0821-06.xlsSD0821-09.xlsSD0821-12.xls


SD0821-13.xlsSD0821-14.xlsSD0821-15.xlsSD0821-16.xls
SD0821-19.xlsSD0821-21.xlsSD0821-22.xlsSD0821-23.xls
SD0821-24.xlsSD0821-25.xlsSD0821-26.xlsSD0821-27.xls
SD0821-28.xlsSD0821-29.xls

Test cases consider legacy customer master data from the table ZNE_CUST_REF:

Test ID
 Test Scenarios
 Expected Results
 Master Data/Actual Results
 P/F
 Examples
 File
 Notes
 tested by
 Quality analysis By
1
 Input legacy Sold-to and SAP Ship-to
 Contract should be created with SAP Sold-to & Ship-to
 455216 & 2000167
Contract was created with SAP Sold-to & Ship-to maintained in the legacy table
 P
 0040001842
 Test1
 N/A
 Surya
 Surya
2
 Input SAP Sold-to & Ship-to
 Contract should be created with SAP Sold-to & Ship-to
 1010550 & 2000171
Contract should be created with SAP Sold-to & Ship-to
 P
 0040001843
 Test2
 N/A
 Surya
 Surya
3
 Input SAP Sold-to and legacy Ship-to
 Contract should be created with SAP Sold-to & Ship-to
 1010532 & M00020
Contract should be created with SAP Sold-to & Ship-to maintained in the legacy table
 P
 00040001844
 Test3
 N/A
 Surya
 Surya
4
 Input legacy Sold-to & Ship-to
 Contract should be created with SAP Sold-to & Ship-to
 C00020 & M00020
Contract should be created with SAP Sold-to & Ship-to maintained in the legacy table
 P
 00040001845
 Test4
 N/A
 Surya
 Surya
5
 Input legacy Sold-to and SAP Ship-to; SAP Sold-to not maintained in table
 Contract should not be created; "Valid Sold-to not found"
 C00025 & 2000168
Contract was not created; system message “Invalid SoldTo C00025”
 P
 NA
 Test5
 N/A
 Surya
 Surya
6
 Input legacy Ship-to and SAP Sold-to; SAP Ship-to not maintained in table
 Contract should not be created; "Valid Ship-to not found"
 M00025 & 1010535
Contract was not created; system message “Invalid ShipTo M00025”
 P
 NA
 Test6
 N/A
 Surya
 Surya
7
 Input legacy Sold-to & Ship-to; SAP Sold-to & Ship-to not maintained in table
 Contract should not be created; "Valid Sold-to and Ship-to not found"
 C00025 & M00025
Contract was not created; system message “Invalid SoldTo C00025”
 P
 NA
 Test7
 N/A
 Surya
 Surya
8
 Input SAP Sold-to and legacy Ship-to; Ship-to not maintained in customer master
 Contract should not be created; "Ship-to not found"
 1010532 & M00021
Contract was not created; system message “No customer master record exists for customer 2000169”
 P
 NA
 Test8
 N/A
 Surya
 Surya
Test1.xlsxTest2.xlsxTest3.xlsxTest4.xlsx
Test5.xlsxTest6.xlsxTest7.xlsxTest8.xlsx

System: NECNEQ100


None


Reference Document (Specification or Production Support Break Fix)


Venkat - 2014-07-15 - 10735 - Spec - New Era Japan IT Deployment - Contract Creation from Order Sheet